﻿<%@ Page Title="" Language="VB" MasterPageFile="~/Prototype.master" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="Members_Default" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<h2>Who are the neighborhood watch group?</h2>
<p>The members that make up the watch group can be seen below</p>
    <p>&nbsp;</p>
    <p>
        <asp:GridView ID="GridView1" runat="server" AllowSorting="True" 
            AutoGenerateColumns="False" DataKeyNames="ID" DataSourceID="SqlDataSource1">
            <Columns>
                <asp:BoundField DataField="FirstName" HeaderText="FirstName" 
                    SortExpression="FirstName" />
                <asp:BoundField DataField="LastName" HeaderText="LastName" 
                    SortExpression="LastName" />
                <asp:BoundField DataField="Role" HeaderText="Role" SortExpression="Role" />
                <asp:ImageField DataImageUrlField="Mem_Images" HeaderText="Image">
                </asp:ImageField>
                <asp:HyperLinkField DataNavigateUrlFields="ID" 
                    DataNavigateUrlFormatString="MemberDetails.aspx?ID={0}" DataTextField="ID" 
                    DataTextFormatString="Details" HeaderText="More Details" Text="Details" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:myFirstDatabase %>" 
            ProviderName="<%$ ConnectionStrings:myFirstDatabase.ProviderName %>" 
            
            SelectCommand="SELECT [FirstName], [LastName], [Role], [ID], [Mem_Images] FROM [Members]">
        </asp:SqlDataSource>
    </p>
</asp:Content>

